from app import create_app, db
from app.models import ChargingPileReport

app = create_app()
app.app_context().push()
db.create_all()

for i in range(5):
    accumulative_service_cost = db.Column(db.Float)
    temp = ChargingPileReport(charging_pile_id=str(i+1), cumulative_charging_times=0, cumulative_charging_duration=0,
                              accumulative_charging_quantity=0, accumulative_charging_cost=0, accumulative_service_cost=0, accumulative_total_cost=0)
    db.session.add(temp)
    db.session.commit()
